SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 55811: SAS® Real-Time Decision Manager sasciutils -loadtreatments returns errors when LIST_DISPLAY_VALUE_COLUMN or LIST_VALUE_COLUMN is null

DetailsHotfixAboutRate It

SAS Real-Time Decision Manager enables you to load treatment custom details using the sasciutils utility program. However, sasciutils returns an error if you attempt to load a list-type custom detail for which the LIST_DISPLAY_VALUE_COLUMN column or LIST_VALUE_COLUMN field is empty:

...
Unable to read list item table VALUES for custom detail <variable name> in treatment <treatment name>.
...
Unable to execute query: SQL passthru expression contained these errors: 
ERROR 22-322: Syntax error, expecting one of the following: !, !!,
&, (, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ,
EQT, FROM, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||,
~=....  ERROR 22-322: Syntax error, expecting one of the following: a quoted
string, !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, AS, BETWEEN,
CONTAINS, EQ, EQT, FORMAT, FROM, GE, GET, GT, GTT, IN, INFORMAT, INTO, IS,
LABEL, LE, LEN, LENGTH, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, TRANSCODE,
^, ^=, |, ||, ~, ~=. 22: LINE and COLUMN cannot be determined....  NOTE 242-205:
NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and
COLUMN where the error has occurred....  ERROR 76-322: Syntax error, statement
will be ignored. 76: LINE and COLUMN cannot be determined....  NOTE: NOSPOOL is
on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN
where the error has occurred.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Real-Time Decision ManagerMicrosoft® Windows® for x646.36.49.4 TS1M0
64-bit Enabled AIX6.36.49.4 TS1M0
64-bit Enabled Solaris6.36.49.4 TS1M0
HP-UX IPF6.36.49.4 TS1M0
Linux for x646.36.49.4 TS1M0
Solaris for x646.36.49.4 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.